package com.info.zhiduoduo.repository.mapper.taxer;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.info.zhiduoduo.repository.dto.maker.MakerBalanceDto;
import com.info.zhiduoduo.repository.entity.taxer.TaxerInvoiceProject;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  发票项目信息 Mapper 接口
 * </p>
 *
 * @author bob
 * @since 2019-12-16
 */
public interface TaxerInvoiceProjectMapper extends BaseMapper<TaxerInvoiceProject> {

	@Select(" select * from zdd_taxer_invoice_project tip " +
			" where tip.userid = #{userid} " +
			" and tip.projectname like '%${projectname}%' " +
			" and tip.deleted = 0 ")
	List<TaxerInvoiceProject> getProjectList(int userid, String projectname);





}
